package com.r_z.mapper;

import com.r_z.entity.UserRole;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @author 梁俊
 * @date 2023/5/30
 * &@version 1.0
 */
@Mapper
public interface UserRoleMapper {

    /**
     * 分页模糊查
     * @param map 集合
     * @return
     */
    @Select("SELECT * FROM userRole WHERE userRoleName LIKE #{userRoleName} limit #{page},#{limit}")
    public List<UserRole> selectLikeUserRole(Map map);

    @Select("select count(*) from userRole WHERE userRoleName LIKE #{userRoleName}")
    public int selectCountUserRole(String userRoleName);
}
